begin tran
declare @upd_id int
select @upd_id = convert(int, var_data) from igs_parm with(updlock) where var_name = 'gv_upd_id'

update ms_style set size_group ='28-36     ' , upd_id = @upd_id where style_no = 'KFAHPT3849 ' 
update pos_sku set size = case size when 'S' then '28' 
									when 'M' then '30'
									when 'L' then '32'
									when 'XL' then '34'
									when 'XXL' then '36' end, 
upd_id = @upd_id  where style_no = 'KFAHPT3849 '

update  ms_style_size set size = case size when 'S' then '28' 
									when 'M' then '30'
									when 'L' then '32'
									when 'XL' then '34'
									when 'XXL' then '36' end
where style_no = 'KFAHPT3849 '

update pur_size set size = case size when 'S' then '28' 
									when 'M' then '30'
									when 'L' then '32'
									when 'XL' then '34'
									when 'XXL' then '36' end
from pur_dtl a
where pur_size.pur_id = a.pur_id and pur_size.seq_no = a.seq_no and a.style_no = 'KFAHPT3849 ' 
select * from pos_sku where style_no = 'KFAHPT3849 ' 
select * from ms_style where style_no = 'KFAHPT3849 ' 

commit tran
 
